SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 54599: A syntax error might occur when you run a procedure against a SAS® Information Map that references negative numbers

DetailsAboutRate It

When you run a procedure against a SAS Information Map, you might see errors that are similar to the following:

 Error while submitting SAS code
  17           ( case when table1.Age in (-1, 11, 12, 14, 15, 16) then 999 else 13 end )  IN  ( (-1),
                                                                                                 _
                                                                                                 22
                                                                                                 76
  ERROR 22-322: Syntax error, expecting one of the following: (, SELECT.
  ERROR 76-322: Syntax error, statement will be ignored.

This error occurs if the information map includes an expression that references negative numbers in an IN clause. For example, if you insert a data item with the following expression into the information map, the error occurs when you attempt to run a procedure against the information map.

insert dataitem name = 'Student Age' expression = 'case when <> in (-1, 11, 12, 14, 15, 16) then 999 else 13 end' type = character id = 'age';

To resolve this issue, add the following option to the JREOPTIONS section of your sasv9.cfg file. You must be running SAS® 9.4_M2 or later to use the option.

-DSASQueryServices.BiqNoNegParens=Y


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASAster Data nCluster on Linux x649.3 TS1M09.4 TS1M2
DB2 Universal Database on AIX9.3 TS1M09.4 TS1M2
DB2 Universal Database on Linux x649.3 TS1M09.4 TS1M2
Greenplum on Linux x649.3 TS1M09.4 TS1M2
Netezza TwinFin 32bit blade9.3 TS1M09.4 TS1M2
Netezza TwinFin 32-bit SMP Hosts9.3 TS1M09.4 TS1M2
Netezza TwinFin 64-bit S-Blades9.3 TS1M09.4 TS1M2
Netezza TwinFin 64-bit SMP Hosts9.3 TS1M09.4 TS1M2
Teradata on Linux9.3 TS1M09.4 TS1M2
z/OS9.3 TS1M09.4 TS1M2
Z649.3 TS1M09.4 TS1M2
Microsoft® Windows® for x649.3 TS1M09.4 TS1M2
Microsoft Windows Server 2003 Datacenter Edition9.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.3 TS1M0
Microsoft Windows Server 2003 for x649.3 TS1M0
Microsoft Windows Server 20089.3 TS1M09.4 TS1M2
Microsoft Windows Server 2008 R29.3 TS1M09.4 TS1M2
Microsoft Windows Server 2008 for x649.3 TS1M09.4 TS1M2
Microsoft Windows XP Professional9.3 TS1M0
Windows 7 Enterprise 32 bit9.3 TS1M09.4 TS1M2
Windows 7 Enterprise x649.3 TS1M09.4 TS1M2
Windows 7 Home Premium 32 bit9.3 TS1M09.4 TS1M2
Windows 7 Home Premium x649.3 TS1M09.4 TS1M2
Windows 7 Professional 32 bit9.3 TS1M09.4 TS1M2
Windows 7 Professional x649.3 TS1M09.4 TS1M2
Windows 7 Ultimate 32 bit9.3 TS1M09.4 TS1M2
Windows 7 Ultimate x649.3 TS1M09.4 TS1M2
Windows Vista9.3 TS1M0
Windows Vista for x649.3 TS1M0
64-bit Enabled AIX9.3 TS1M09.4 TS1M2
64-bit Enabled HP-UX9.3 TS1M09.4 TS1M2
64-bit Enabled Solaris9.3 TS1M09.4 TS1M2
HP-UX IPF9.3 TS1M09.4 TS1M2
Linux9.3 TS1M09.4 TS1M2
Linux for x649.3 TS1M09.4 TS1M2
Solaris for x649.3 TS1M09.4 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.